<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ page import="unit.EscapeUnescape"%>
<%@ page import="websql.DBcon"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
	request.setCharacterEncoding("UTF-8");
	String conname = request.getParameter("conname");
	String drv = request.getParameter("drv");
	String url = request.getParameter("url");
	String usr = request.getParameter("usr");
	String psd = request.getParameter("psd");
	String cid = request.getParameter("cid");
	String sql = "";
	String stp = request.getParameter("st");
	if (stp.equals("新增")) {
		sql = "insert into conn (cname,drv,url,usr,psd) values ('"
				+ EscapeUnescape.escape(conname) + "','"
				+ EscapeUnescape.escape(drv) + "','"
				+ EscapeUnescape.escape(url) + "','"
				+ EscapeUnescape.escape(usr) + "','"
				+ EscapeUnescape.escape(psd) + "')";
	}
	if (stp.equals("修改")) {
		sql = "update conn set cname='"
				+ EscapeUnescape.escape(conname) + "', drv='"
				+ EscapeUnescape.escape(drv) + "', url='"
				+ EscapeUnescape.escape(url) + "', usr='"
				+ EscapeUnescape.escape(usr) + "', psd='"
				+ EscapeUnescape.escape(psd) + "' where cid='" + cid
				+ "'";
	}
	if (stp.equals("删除")) {
		sql = "delete from conn where cid='" + cid + "'";
	}
	try {
		DBcon.exsql(sql);
	} catch (Exception e) {out.println("<xmp>发生异常,如果是删除数据库连接，请确保数据库连接下的所有查询都已删除");
	out.println("sql语句：\n"+sql+"\n");
	out.println("异常信息:\n"+e+"\n");
	out.println("堆栈信息:\n"+e.getStackTrace()+"\n</xmp>");
	}
	;
%>

</body>
</html>